package net.skyaims.sqlmgr.domain;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.skife.jdbi.v2.StatementContext;
import org.skife.jdbi.v2.tweak.ResultSetMapper;

import lombok.Data;

@Data
public class NodeTable implements ResultSetMapper<NodeTable> {

	private Integer seqid;

	private String uuid;

	private Integer nid;

	private String name;

	private Integer operator;

	private Integer province;

	private Integer city;

	private Integer state;

	private String comment;

	@Override
	public NodeTable map(int index, ResultSet r, StatementContext ctx) throws SQLException {
		NodeTable node = new NodeTable();
		node.setSeqid(r.getInt("seqid"));
		node.setNid(r.getInt("nid"));
		node.setUuid(r.getString("uuid"));
		return node;
	}

}
